

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ads_steam_games_age_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_age_cnt`;
CREATE TABLE `ads_steam_games_age_cnt` (
  `required_age` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='游戏年龄要求情况';

-- ----------------------------
-- Records of ads_steam_games_age_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_age_cnt` (`required_age`, `cnt`) VALUES ('0', 26479);
INSERT INTO `ads_steam_games_age_cnt` (`required_age`, `cnt`) VALUES ('3', 11);
INSERT INTO `ads_steam_games_age_cnt` (`required_age`, `cnt`) VALUES ('7', 12);
INSERT INTO `ads_steam_games_age_cnt` (`required_age`, `cnt`) VALUES ('12', 73);
INSERT INTO `ads_steam_games_age_cnt` (`required_age`, `cnt`) VALUES ('16', 192);
INSERT INTO `ads_steam_games_age_cnt` (`required_age`, `cnt`) VALUES ('18', 308);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_category_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_category_cnt`;
CREATE TABLE `ads_steam_games_category_cnt` (
  `categories` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `positive_rate` decimal(10,2) DEFAULT NULL,
  `negative_rate` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='每种游戏的好评率、差评率';

-- ----------------------------
-- Records of ads_steam_games_category_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Captions available', 0.91, 0.09);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Co-op', 0.84, 0.16);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Commentary available', 0.94, 0.06);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Cross-Platform Multiplayer', 0.87, 0.13);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Full controller support', 0.85, 0.15);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('In-App Purchases', 0.82, 0.18);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Includes Source SDK', 0.94, 0.06);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Includes level editor', 0.89, 0.11);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Local Co-op', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Local Multi-Player', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('MMO', 0.71, 0.29);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Mods', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Mods (require HL2)', 0.85, 0.15);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Multi-player', 0.81, 0.19);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Online Co-op', 0.79, 0.21);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Online Multi-Player', 0.74, 0.26);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Partial Controller Support', 0.84, 0.16);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Shared/Split Screen', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Single-player', 0.84, 0.16);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Stats', 0.83, 0.17);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Steam Achievements', 0.85, 0.15);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Steam Cloud', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Steam Leaderboards', 0.84, 0.16);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Steam Trading Cards', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Steam Turn Notifications', 0.74, 0.26);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Steam Workshop', 0.87, 0.13);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('SteamVR Collectibles', 0.86, 0.14);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('VR Support', 0.83, 0.17);
INSERT INTO `ads_steam_games_category_cnt` (`categories`, `positive_rate`, `negative_rate`) VALUES ('Valve Anti-Cheat enabled', 0.86, 0.14);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_developer_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_developer_cnt`;
CREATE TABLE `ads_steam_games_developer_cnt` (
  `developer` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='前20的开发商\n';

-- ----------------------------
-- Records of ads_steam_games_developer_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Choice of Games', 94);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('KOEI TECMO GAMES CO., LTD.', 72);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Ripknot Systems', 62);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Laush Dmitriy Sergeevich', 51);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Nikita \"Ghost_RUS', 50);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Dexion Games', 45);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('RewindApp', 43);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Hosted Games', 42);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Blender Games', 40);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Humongous Entertainment', 36);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('For Kids', 36);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('EnsenaSoft', 35);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Nekyau Games', 32);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Eipix Entertainment', 32);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Warfare Studios', 31);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('HeR Interactive', 30);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('MumboJumbo', 29);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('ERS G Studios', 28);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('Creobit', 28);
INSERT INTO `ads_steam_games_developer_cnt` (`developer`, `cnt`) VALUES ('HexWar Games', 27);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_platform_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_platform_cnt`;
CREATE TABLE `ads_steam_games_platform_cnt` (
  `platform` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='平台游戏数量分布';

-- ----------------------------
-- Records of ads_steam_games_platform_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_platform_cnt` (`platform`, `cnt`) VALUES ('linux', 5235);
INSERT INTO `ads_steam_games_platform_cnt` (`platform`, `cnt`) VALUES ('mac', 8066);
INSERT INTO `ads_steam_games_platform_cnt` (`platform`, `cnt`) VALUES ('windows', 27070);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_price_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_price_cnt`;
CREATE TABLE `ads_steam_games_price_cnt` (
  `price_label` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='游戏价格分布';

-- ----------------------------
-- Records of ads_steam_games_price_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('0-10', 19593);
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('10-20', 3999);
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('20-30', 600);
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('30-50', 285);
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('50-100', 27);
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('免费', 2560);
INSERT INTO `ads_steam_games_price_cnt` (`price_label`, `cnt`) VALUES ('超过100', 11);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_publisher_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_publisher_cnt`;
CREATE TABLE `ads_steam_games_publisher_cnt` (
  `publisher` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='前20的出版商\n';

-- ----------------------------
-- Records of ads_steam_games_publisher_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Big Fish Games', 212);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Strategy First', 136);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Ubisoft', 111);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('THQ Nordic', 98);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Square Enix', 97);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Sekai Project', 96);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Choice of Games', 94);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('1C Entertainment', 88);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Dagestan Technology', 88);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('SEGA', 78);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Degica', 77);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Plug In Digital', 72);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('KISS ltd', 71);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Slitherine Ltd.', 71);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('KOEI TECMO GAMES CO., LTD.', 71);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('AGM PLAYISM', 69);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Artifex Mundi', 67);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Buka Entertainment', 66);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Devolver Digital', 65);
INSERT INTO `ads_steam_games_publisher_cnt` (`publisher`, `cnt`) VALUES ('Atriagames', 64);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_tags_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_tags_cnt`;
CREATE TABLE `ads_steam_games_tags_cnt` (
  `tags` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='游戏特征词云图';

-- ----------------------------
-- Records of ads_steam_games_tags_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('1980s', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('1990\'s', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('2.5D', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('2D', 163);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('2D Fighter', 41);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('360 Video', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('3D', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('3D Platformer', 42);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('3D Vision', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('4 Player Local', 44);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('4X', 37);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('6DOF', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Abstract', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Action', 10322);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Action RPG', 20);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Action-Adventure', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Adventure', 7770);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Agriculture', 24);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Aliens', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Alternate History', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('America', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Animation & Modeling', 54);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Anime', 538);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Arcade', 203);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Arena Shooter', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Assassin', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Atmospheric', 85);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Audio Production', 20);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('BMX', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Base-Building', 26);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Baseball', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Basketball', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Batman', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Battle Royale', 24);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Beat \'em up', 47);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Beautiful', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Benchmark', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Bikes', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Blood', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Board Game', 105);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Bowling', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Building', 62);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Bullet Hell', 96);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Bullet Time', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('CRPG', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Capitalism', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Card Game', 164);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cartoon', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cartoony', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Casual', 8205);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cats', 15);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Character Action Game', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Character Customization', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Chess', 16);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Choices Matter', 32);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Choose Your Own Adventure', 29);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cinematic', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('City Builder', 71);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Class-Based', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Classic', 170);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Clicker', 64);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Co-op', 120);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cold War', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Colorful', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Comedy', 89);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Comic Book', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Competitive', 12);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Controller', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Conversation', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Crafting', 23);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Crime', 12);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cult Classic', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cute', 40);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cyberpunk', 58);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Cycling', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dark', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dark Fantasy', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dark Humor', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dating Sim', 33);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Demons', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Design & Illustration', 80);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Destruction', 21);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Detective', 42);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Difficult', 85);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dinosaurs', 34);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Diplomacy', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Documentary', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dog', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dragons', 12);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Drama', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Driving', 59);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dungeon Crawler', 45);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dungeons & Dragons', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Dystopian ', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Early Access', 2967);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Economy', 17);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Education', 84);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Epic', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Experimental', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Exploration', 55);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('FMV', 34);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('FPS', 405);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Faith', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Family Friendly', 86);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Fantasy', 115);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Fast-Paced', 18);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Female Protagonist', 199);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Fighting', 117);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('First-Person', 91);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Fishing', 17);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Flight', 64);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Football', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Free to Play', 1662);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Funny', 55);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Futuristic', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Gambling', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Game Development', 23);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('GameMaker', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Games Workshop', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('God Game', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Golf', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Gore', 476);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Gothic', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Grand Strategy', 33);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Great Soundtrack', 125);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Grid-Based Movement', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Gun Customization', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hack and Slash', 83);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hacking', 20);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hand-drawn', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Heist', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hex Grid', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hidden Object', 460);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Historical', 69);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hockey', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Horror', 493);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Horses', 12);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Hunting', 13);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Illuminati', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Indie', 16232);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Intentionally Awkward Controls', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Interactive Fiction', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Inventory Management', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Investigation', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Isometric', 20);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('JRPG', 94);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Kickstarter', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('LEGO', 22);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Lara Croft', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Lemmings', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Level Editor', 15);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Linear', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Local Co-Op', 56);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Local Multiplayer', 80);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Logic', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Loot', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Lovecraftian', 26);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('MMORPG', 31);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('MOBA', 13);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Magic', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Management', 116);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mars', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Martial Arts', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Massively Multiplayer', 377);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Masterpiece', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Match 3', 119);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mature', 37);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mechs', 36);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Medieval', 51);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Memes', 78);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Metroidvania', 56);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Military', 19);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mini Golf', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Minimalist', 31);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mining', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mod', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Moddable', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Motocross', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Motorbike', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mouse only', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Movie', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Multiplayer', 405);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Multiple Endings', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Music', 105);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Music-Based Procedural Generation', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mystery', 66);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mystery Dungeon', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Mythology', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('NSFW', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Narration', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Naval', 39);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Ninja', 13);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Noir', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Nonlinear', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Nudity', 570);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Offroad', 17);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Old School', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('On-Rails Shooter', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Online Co-Op', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Open World', 243);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Otome', 39);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Parkour', 23);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Parody ', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Party-Based RPG', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Perma Death', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Philisophical', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Photo Editing', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Physics', 53);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Pinball', 15);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Pirates', 31);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Pixel Graphics', 249);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Platformer', 648);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Point & Click', 492);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Political', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Politics', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Pool', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Post-apocalyptic', 40);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Procedural Generation', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Programming', 26);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Psychedelic', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Psychological', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Psychological Horror', 76);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Puzzle', 1116);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Puzzle-Platformer', 59);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('PvP', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Quick-Time Events', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('RPG', 2785);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('RPGMaker', 192);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('RTS', 174);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Racing', 765);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Real Time Tactics', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Real-Time', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Real-Time with Pause', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Realistic', 19);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Relaxing', 46);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Remake', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Replay Value', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Resource Management', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Retro', 114);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Rhythm', 48);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Robots', 22);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Rogue-like', 104);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Rogue-lite', 20);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Romance', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Rome', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Runner', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sailing', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sandbox', 94);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Satire', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sci-fi', 157);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Science', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Score Attack', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sexual Content', 557);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Shoot \'Em Up', 245);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Shooter', 101);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Short', 16);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Side Scroller', 12);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Simulation', 3284);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Singleplayer', 161);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Skateboarding', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Skating', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sniper', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Snow', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Snowboarding', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Soccer', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Software', 16);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Software Training', 11);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sokoban', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Souls-like', 12);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Space', 225);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Space Sim', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Spectacle fighter', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Spelling', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Split Screen', 5);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Sports', 781);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Star Wars', 28);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Stealth', 93);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Steampunk', 24);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Story Rich', 159);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Strategy', 4173);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Strategy RPG', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Stylized', 1);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Submarine', 4);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Superhero', 22);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Supernatural', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Surreal', 19);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Survival', 235);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Survival Horror', 51);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Swordplay', 7);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Tactical', 51);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Tactical RPG', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Tanks', 21);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Team-Based', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Tennis', 14);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Text-Based', 23);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Third Person', 25);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Third-Person Shooter', 42);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Thriller', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Time Attack', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Time Management', 33);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Time Manipulation', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Time Travel', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Top-Down', 22);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Top-Down Shooter', 27);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Touch-Friendly', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Tower Defense', 168);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Trading', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Trading Card Game', 13);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Trains', 37);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Turn-Based', 171);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Turn-Based Combat', 21);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Turn-Based Strategy', 103);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Turn-Based Tactics', 22);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Twin Stick Shooter', 44);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Typing', 6);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Underwater', 13);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Utilities', 138);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('VR', 961);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('VR Only', 25);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Vampire', 17);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Video Production', 31);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Villain Protagonist', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Violent', 545);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Visual Novel', 546);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Voice Control', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Voxel', 2);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Walking Simulator', 55);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('War', 25);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Wargame', 18);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Warhammer 40K', 29);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Web Publishing', 9);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Werewolves', 3);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Western', 23);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Word Game', 10);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('World War I', 23);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('World War II', 130);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Wrestling', 8);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('Zombies', 158);
INSERT INTO `ads_steam_games_tags_cnt` (`tags`, `cnt`) VALUES ('e-sports', 2);
COMMIT;

-- ----------------------------
-- Table structure for ads_steam_games_year_cnt
-- ----------------------------
DROP TABLE IF EXISTS `ads_steam_games_year_cnt`;
CREATE TABLE `ads_steam_games_year_cnt` (
  `year_key` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnt` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='每年的新游戏\n';

-- ----------------------------
-- Records of ads_steam_games_year_cnt
-- ----------------------------
BEGIN;
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2010', 238);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2011', 239);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2012', 320);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2013', 418);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2014', 1555);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2015', 2597);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2016', 4361);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2017', 6357);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2018', 8160);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2019', 9230);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2020', 11566);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2021', 12058);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2022', 12674);
INSERT INTO `ads_steam_games_year_cnt` (`year_key`, `cnt`) VALUES ('2023', 13950);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
